﻿<?xml version="1.0" encoding="utf-8" ?>
<DbDataRequest connection="$DBConnection$" type="$ForumDBType$" defaultFormatter="bizobj Approver">
	<SqlStatement hasResults="true">
		SELECT U.ID,U.USERNAME,A.SETID,A.RANK
		FROM USERS U
		INNER JOIN APPROVALSETAPPROVERS A
		ON U.ID = A.APPROVERID
		WHERE A.APPROVALSETID=@id 
	</SqlStatement>
	<Param name="id" type="UniqueIdentifier" />
</DbDataRequest>